<%@ page language="java" import="com.demo.util.Conn,java.sql.ResultSet" pageEncoding="UTF-8"%>
<%
String company_id = request.getParameter("company_id");
String company_name = request.getParameter("company_name");
String Business_Nature = request.getParameter("Business_Nature");
String Job_Title = request.getParameter("Job_Title");
String Job_Nature = request.getParameter("Job_Nature");
String Job_Starting_Date = request.getParameter("Job_Starting_Date");
String Application_Deadline = request.getParameter("Application_Deadline");
String Company_Introduction = request.getParameter("Company_Introduction");
String persion_num = request.getParameter("persion_num");
String Job_Description = request.getParameter("Job_Description");
String Requirement = request.getParameter("Requirement");
String Additional_Information = request.getParameter("Additional_Information");
String Mailing_address = request.getParameter("Mailing_address");
String Website = request.getParameter("Website");
String Contact_Person = request.getParameter("Contact_Person");
String Position_held = request.getParameter("Position_held");
String Department = request.getParameter("Department");
String Email_address = request.getParameter("Email_address");
String Direct_Line = request.getParameter("Direct_Line");
String Facsimile = request.getParameter("Facsimile");

String sql = "insert into DBF_JOB_INFO(company_id,company_name,Business_Nature,Job_Title,Job_Nature,"
				+ "Job_Starting_Date,Application_Deadline,persion_num,Company_Introduction,Job_Description,"
				+ "Requirement,Additional_Information,Mailing_address,Website,Contact_Person,"
				+ "Position_held,Department,Email_address,Direct_Line,Facsimile) "
				+ "values (" + company_id + ",'" + company_name + "','" + Business_Nature 
				+ "','" + Job_Title + "','" + Job_Nature + "','" + Job_Starting_Date  
				+ "','" + Application_Deadline + "','" + persion_num + "','" + Company_Introduction + "','" + Job_Description 
				+ "','" + Requirement + "','" + Additional_Information + "','" + Mailing_address 
				+ "','" + Website + "','" + Contact_Person + "','" + Position_held 
				+ "','" + Department + "','" + Email_address + "','" + Direct_Line + "','" + Facsimile
				+ "')";
System.out.println(sql);
Conn conn = new Conn();
boolean result = conn.update(sql);
String redirect_address = "";
if(result){
	redirect_address = "jobPostSuccess.jsp";
	response.sendRedirect(redirect_address);
}
%>